Latest Microsoft Dynamics 365 Blogs | CloudFronts

Microsoft Fabric Part 1 – Building a Config-Driven Data Ingestion Framework for D365

Summary Why traditional entity-by-entity pipelines do not scale for enterprise data engineering How a config-driven ingestion framework eliminates the need to write new code for every new data entity How two generic pipelines handle authentication, pagination, and incremental upsert loading for any D365 entity How this was built as part of a Microsoft Fabric implementation for a D365 Finance & Operations data platform Table of Contents 1. Let’s Start Here 2. The Challenge 3. The Solution — Config-Driven Ingestion 4. Technical Deep-Dive 5. Business Impact 6. Conclusion Let’s Start Here Every data engineering team eventually hits the same wall. You build a pipeline for one entity — opportunities, invoices, time entries. It works well. Then another entity gets added, and another. Before long, you have a collection of pipelines that each do roughly the same thing but are written differently, maintained separately, and break in different ways. The question is not whether this happens — it always does. The question is whether your framework is designed to prevent it from the start. This is Part 1 of a two-part series on building an end-to-end data engineering framework on Microsoft Fabric connected to Dynamics 365. Before we get into the detail, here is how the full architecture fits together: The Full Architecture — D365 to AI D365 / F&O  →  Bronze Layer (raw ingestion)  →  Silver Layer (cleansed)  →  Gold Layer (business-ready)  →  Power BI Reports + Fabric Data Agent Part 1 covers the ingestion step — pulling data from D365 into the Bronze layer of the Fabric Lakehouse using a config-driven pipeline framework. Part 2 covers everything after Bronze — transformation through Silver and Gold, Direct Lake reporting in Power BI, and conversational AI through the Fabric Data Agent. This part focuses on the ingestion layer — how a single config-driven framework pulls data from any D365 entity and lands it in the Bronze layer of a Fabric Lakehouse, without writing new code for each entity. The Challenge Traditional data engineering approaches treat each entity as a unique problem. A pipeline is built for accounts, another for contacts, another for time entries. Each one has its own authentication logic, its own pagination handling, its own incremental-load approach. This creates a set of problems that compound over time: a.   Onboarding a new entity requires a new pipeline build, test cycle, and deployment — work that can take days b.   Incremental load logic is duplicated across pipelines, often inconsistently, leading to missed records or duplicates c.   When upstream systems change — authentication, API structure, column names — the blast radius is wide d.   There is no single place to look to understand what is being ingested and how The answer is not better pipelines. It is a framework where the pipeline is generic and the entity-specific details live in configuration. The Solution — Config-Driven Ingestion on Microsoft Fabric The ingestion layer of this framework runs entirely from a single Fabric workspace containing one Lakehouse, two pipelines, and one master configuration file. Every entity, its key column, its watermark column, and its source details live in a CSV — not in pipeline code. The Lakehouse is structured using a Medallion architecture — three table layers: Bronze (raw data exactly as it arrives from D365), Silver (cleansed and standardised), and Gold (business-ready, joined, and logic-applied). The ingestion framework is responsible for the first step — getting data from D365 into the Bronze layer reliably, incrementally, and without entity-specific code. The Fabric workspace — one Lakehouse, two pipelines, and a config file that together handle ingestion for any number of D365 entities Adding a new entity to the framework means adding one row to a CSV. No new pipeline. No new deployment. No code change. Technical Deep-Dive The Lakehouse and Config Files Inside CRM_Lakehouse, the Tables area is organised by Medallion layer. The Files area holds the configuration CSVs that drive every pipeline and notebook. Three files do all the work: ingestion.csv — controls which entities are ingested, how they are filtered, and where they land b2s_columnconfig.csv — controls Bronze-to-Silver column mapping, aliasing, and type casting gold_fixed.csv — controls Gold-layer business logic and join definitions The Lakehouse holds both the data layers and the config files that drive every pipeline and notebook — everything in one place The Master Config — ingestion.csv Every entity is described in a single row of ingestion.csv. Each row contains: Entity name and OData logical name — what to call and where to find it in D365 Primary key column — used for upsert to prevent duplicates Incremental filter column — the watermark field used to fetch only changed records Partition key — supports multi-source ingestion Checkpoint — stores the last watermark value applied so each run picks up exactly where the last one left off The pipeline reads this file, builds its incremental filter dynamically, and upserts records using the configured key. No entity-specific code exists anywhere. ingestion.csv — every entity is a single self-describing row. Adding a new D365 entity is a config change, not a code change The Trigger Pipeline The Data Ingestion Trigger pipeline is the orchestrator. It works in three steps: Lookup — reads ingestion.csv and returns the full list of configured entities ForEach — loops through every entity row in the config Invoke Pipeline — calls the Entity pipeline once per row, passing the full config object as a parameter One lightweight orchestrator pipeline controls an unlimited number of entities — no changes needed when a new entity is added. The Trigger pipeline — Lookup config, loop through entities, invoke the Entity pipeline once per row The Entity Pipeline The Data Ingestion Entity pipeline is the reusable worker. It receives a single entityConfig parameter and executes three steps: Get Access Token — authenticates against D365/F&O via OAuth using the entity config Set Variable — stores the token for use in the next activity Copy Data — calls the correct OData endpoint, handles pagination, and loads the result into the … Continue reading Microsoft Fabric Part 1 – Building a Config-Driven Data Ingestion Framework for D365

Share Story :

How an Industrial Cybersecurity Company in Texas Improved Field Time and Expense Tracking with Microsoft Power Apps and Dynamics 365 Project Operations

Summary Designed and deployed a mobile-first Power Apps Canvas App for a Texas-based industrial cybersecurity firm specializing in operational technology (OT) security for oil and gas infrastructure. Unified time tracking, expense management, material consumption logging, and approvals into a single experience integrated with Dynamics 365 Project Operations. Eliminated fragmented desktop-based workflows that delayed project reporting, approvals, and billing. Automated expense receipt processing through Power Automate, improving compliance and reducing manual effort. Implemented project-scoped approval routing to ensure submissions were reviewed only by authorized stakeholders. Enabled real-time project visibility through structured Dataverse-driven workflows and lifecycle tracking. Provided mobile approvals and submission monitoring, dramatically reducing turnaround times. Improved data accuracy, audit readiness, and billing efficiency across field operations. Table of Contents Introduction Requirement & Business Scenario Solution Implementation Implementation Gallery Outcome FAQs Conclusion 1. Introduction Field-driven organizations live and die by the accuracy and speed of their project data. For a company securing critical infrastructure like oil rigs, every hour an engineer spends fighting with a clunky time-entry screen is an hour not spent on the job site — and every delayed expense submission is a delay in client billing and financial reporting. This is the story of how a Texas-based cybersecurity firm moved away from a fragmented, desktop-oriented workflow inside Dynamics 365 Project Operations and adopted a unified, mobile-first Canvas App that brought time tracking, expense submission, and material logging into one place, with built-in compliance controls and project-specific approval routing. The Goal: Build a unified mobile-first experience that allows field engineers to submit time, expenses, and materials from anywhere while ensuring compliance, controlled approvals, and real-time project visibility. 2. Requirement & Business Scenario The firm manages multiple concurrent field engagements using Dynamics 365 Project Operations as its system of record. Consultants and field engineers were expected to log three categories of activity against active projects: Time entries for hours worked Expense entries covering travel, accommodation, airfare, and related costs Material usage logs for equipment, parts, and consumables The core issue was that the underlying system was built for desktop use, not for engineers working on-site at remote rig locations. This created several compounding problems: Field staff had no efficient way to submit entries from a mobile device, so submissions piled up until they were back at a desk. Time, expense, and material tracking lived in separate workflows, forcing users to context-switch between screens for what should have been a single daily task. Expense compliance was inconsistent — receipts were sometimes attached, sometimes forgotten, and the process for linking a receipt to an expense record involved several manual, error-prone steps behind the scenes. Approvals had no project-level boundaries, making it hard to guarantee that only the right project stakeholders could review and approve specific submissions. Project managers lacked real-time visibility into resource usage, which meant billing and client reporting cycles were consistently delayed. Left unaddressed, these gaps were directly affecting data accuracy, audit readiness, and the speed at which the business could invoice clients. 3. Solution CloudFronts designed a unified mobile experience using Power Apps Canvas Apps layered on top of Dynamics 365 Project Operations and Dataverse, built around one guiding principle: One App. All Submissions. Controlled Approvals. Real-Time Visibility. For field users, the app became the single place to submit time entries on a daily or weekly basis, create expense entries with automatic receipt handling, log material consumption against the correct project, and track the live status of every submission. For project approvers, the same app surfaced only the entries tied to projects they were actually responsible for, let them approve or reject submissions directly from their phone, and preserved a clean, audit-ready trail for every decision. Day Mode and Week Mode Users could switch between a detailed single-day entry view, useful for precise logging and corrections, and a bulk weekly view that sped up repetitive data entry — letting each person work the way that suited their role. Calendar-Based Swipe Navigation A Dynamics-style calendar with swipe gestures let users move quickly across days and weeks, reviewing or correcting historical entries without friction. Stage-Aware Interface Every record followed the same lifecycle — Submitted, Pending, Approved, Rejected, Recall Requested, Recall Approved, Recall Rejected — and the UI adapted to whatever stage a record was in. Action buttons such as Submit, Approve, Reject, and Recall only appeared when they were actually valid, significantly reducing user confusion and accidental actions. Conditional Receipt Enforcement Rather than requiring a receipt for every expense category, the app applied compliance rules selectively. Receipts were mandatory for airfare and OT hardware purchases, while remaining optional for lower-risk categories such as meals and local transportation. 4. Implementation The technical implementation centered on a unified Dataverse data model and a set of automations that removed manual work from both the field user and the back office. Unified Data Model Time, expense, and material entries were all structured in Dataverse and linked back to the relevant project, resource, approval record, and — for expenses — supporting documentation. Every submission created a record with a clearly defined lifecycle stage, ensuring all three entry types behaved consistently even though their underlying business logic differed. Validation Before Submission The Canvas App enforced field-level validation before allowing a record to be saved, checking that essentials such as transaction date, project, category, quantity, and cost information were populated. If( Or( IsBlank(DatePicker.SelectedDate), IsBlank(ProjectCombobox.Selected), IsBlank(CategoryCombobox.Selected), IsBlank(QuantityInput.Value), IsBlank(PriceInput.Value) ), Notify(“Required fields are missing.”, NotificationType.Error) ) Patch-Based Record Creation Once validation passed, the application used Dataverse Patch operations to create records and calculate derived values such as expense subtotals dynamically based on quantity and unit price. Automated Receipt Handling For expense submissions, the previously manual chain of creating an Expense Receipt record, attaching a file as a Note, converting it to the correct document format, and updating the status to Submitted was fully automated. The Canvas App passed the expense ID, file name, and file content to a Power Automate flow, which created the Expense Receipt record, stored the file as a Note (Annotation) with the correct MIME type, … Continue reading How an Industrial Cybersecurity Company in Texas Improved Field Time and Expense Tracking with Microsoft Power Apps and Dynamics 365 Project Operations

Share Story :

Mastering MRP: From Disconnected Data to Unified Insights for a Leading North American Commercial Vehicle Manufacturing Company

Summary Large manufacturing companies depend on Material Requirements Planning (MRP) to manage demand, supply, inventory, procurement, and production. In many organizations, planning data is spread across ERP systems, legacy applications, spreadsheets, and manufacturing systems, making it difficult to answer a critical question: Will we have the right material at the right time? A centralized MRP reporting solution built using Dynamics 365 and Power BI provides a single view of demand, inventory, procurement, production, and supplier performance. The result is better visibility, faster planning decisions, reduced manual effort, and improved supply chain performance. Table of Contents Customer Spotlight The Challenge The Solution Executive Supply Chain Overview Detailed MRP Analysis MRP Trends Over Time Inventory Optimization & Supplier Performance Production Planning Insights Business Impact FAQs Conclusion Customer Spotlight A Large Manufacturing Company in North America The organization manages complex manufacturing operations involving procurement, inventory, warehousing, production planning, and supplier management. Their planning environment includes: Large volumes of customer demand Thousands of raw material items Multiple suppliers and sourcing channels Complex production schedules Inventory distributed across warehouses and plants The Challenge The challenge was not a lack of data but having too much disconnected data across multiple systems. Planning teams needed answers to questions such as: Which materials may cause production shortages? Is demand data accurate? Are materials being ordered at the correct time and quantity? Which items are overstocked or understocked? Which suppliers are causing delays? Can production begin without material shortages? Which items require urgent planner attention? The Solution The solution combines Dynamics 365 planning data with Power BI reporting capabilities. Demand from sales orders and forecasts Inventory and on-hand balances Planned purchase orders Planned production orders Planned transfer orders Purchase orders and supplier data Bills of Materials (BOM) Production routes Lead times Safety stock parameters Executive Supply Chain Overview The dashboard provides a high-level view of supply chain performance and enables filtering by Site, Warehouse, Item, Supplier, Planner, and Date. Demand Visibility Demand vs Supply Inventory Health Stock & Shortages Supplier Metrics OTIF & Delays Detailed MRP Analysis The dashboard helps planners understand why MRP generated a recommendation. Item details and inventory balances Demand and supply transactions Planned orders Net requirements Lead times Order quantities MRP exception messages MRP Trends Over Time The trend dashboard enables proactive planning by highlighting: Demand changes over time Inventory movement trends Material shortages Purchase order delays Forecast accuracy Inventory Optimization & Supplier Performance The objective is simple: Right Material, Right Place, Right Time. The dashboard identifies: Items below safety stock Excess inventory Slow-moving inventory Location-based shortages Inventory in transit Supplier performance is measured using: On-time delivery OTIF (On Time In Full) Lead-time performance Supplier delays Open purchase orders Production Planning Insights This dashboard connects production planning with material planning. Production order status Material availability Capacity constraints Work-In-Progress (WIP) Production delays Business Impact Before After Data spread across systems Centralized visibility Manual reporting Automated insights Late issue detection Early issue identification Reactive planning Proactive decision-making Disconnected processes Connected planning view Limited executive visibility Real-time dashboards FAQs 1. Does Dynamics 365 support MRP? Yes. Dynamics 365 supports Material Requirements Planning and automatically generates planned orders based on demand and supply. 2. Why use Power BI? Power BI transforms planning data into actionable dashboards and visual insights. 3. What data is typically included? Inventory, sales orders, forecasts, purchase orders, suppliers, planned orders, and production data. 4. Can legacy planning systems be integrated? Yes. External planning and demand data can be consolidated into the reporting solution. 5. Can shortages and supplier performance be tracked? Yes. Dashboards can track shortages, supplier reliability, OTIF, and delivery performance. Conclusion MRP is not simply about generating planned orders. It is about making better business decisions. When Dynamics 365 planning data is combined with Power BI analytics, organizations gain visibility into demand, inventory, procurement, supplier performance, and production readiness. Instead of asking “Why did production stop?”, organizations can focus on “What should we act on today to prevent tomorrow’s disruption?” The result is a more proactive and data-driven approach to manufacturing planning that improves service levels, reduces risk, and enhances operational performance.

Share Story :

From Quote to Signed Contract in Minutes: Automating Adobe Acrobat Sign Integration for an Australia based Linen and Garments company

Summary Automated end-to-end contract generation, digital signing, and document filing for an Australia-based commercial linen and garments company using Dynamics 365 Sales, Microsoft Power Automate, and Adobe Acrobat Sign. Eliminated manual contract preparation by generating personalized Word contracts directly from accepted Dynamics 365 Quotes using a reusable Word template. Leveraged Adobe Acrobat Sign text tags embedded within the Word template to automatically create signature, date, and fillable fields without manual field placement or custom development. Automated agreement creation, customer notifications, and real-time signing status tracking through Adobe Acrobat Sign, providing complete visibility throughout the contract lifecycle. Implemented a dedicated child Power Automate flow that automatically identified completed agreements from Adobe Sign emails and archived signed contracts into the correct SharePoint document library. Reduced contract turnaround from a manual, multi-step process to a one-click, fully automated workflow while ensuring audit-ready signed documents and eliminating manual document handling. Table of Contents Introduction Business Challenge Procedure End-to-End Flow Why This Approach Works Conclusion Introduction For any business that runs on contracts — service agreements, quotes-turned-orders, vendor sign-offs — the gap between "quote accepted" and "contract signed" is often where deals slow down. Manual document preparation, back-and-forth emails, chasing signatures, and manually filing signed copies all eat into time that should be spent serving the customer. For an Australia based Linen and Garments, a commercial textile services company, CloudFronts built an end-to-end automation that takes a sales quote all the way through to a fully signed, filed contract — with zero manual document handling in between. The solution combines a Word contract template, Microsoft Power Automate, and Adobe Acrobat Sign, orchestrated across two connected flows: a parent flow that creates and sends the contract, and a child flow that listens for the signed response and files it automatically. This post walks through how that solution works, including the one detail that makes the whole thing possible without any custom code: Adobe Sign text tags embedded directly inside the Word template. The Business Challenge Once a quote is accepted, the team needed the resulting contract to: Be generated automatically from the quote and its line items — no manual copy-pasting of customer details into a Word document. Be sent for signature immediately, with the right fields ready for the customer to fill in and sign — bank details, account information, and a signature block, all in the right place. Notify both the customer and the internal Adobe Sign account holder the moment it’s out for signing. Automatically file the final, fully signed PDF back into the correct SharePoint location tied to that quote — without anyone needing to remember to save it. Doing this by hand across multiple people and mailboxes was slow and error-prone. The goal was to make the entire journey — quote to signed, filed contract — happen in minutes, with no manual document work at any step. Procedure Step 1: Auto-Generating the Contract from the Quote The process starts with a single action: Create Contract. This triggers the parent Power Automate flow, which: Composes the Quote ID from the selected record. Retrieves the document location tied to that quote (the Word contract template). Pulls the Quote, the associated Customer, and the Contact record for the signer. Uses these to populate a Word template — the standard “Populate a Word Template” merge step — filling in customer name, contract terms, line items, and contact details automatically. This is the same idea used in most contract-automation flows: merge structured CRM/quote data into a pre-built Word template, so the resulting document is fully personalized without a single manual edit. Step 2: Making the Contract Signable — Text Tags in the Template This is the step that makes the entire signing experience work, and it's worth explaining properly, because it's easy to get wrong. A merged Word document, by itself, is just static text. For Adobe Acrobat Sign to know where a customer needs to sign, initial, or fill something in, the template needs special markers called text tags — plain text strings embedded directly into the Word template before it's ever merged. When the finished document is sent to Adobe Sign, Adobe automatically scans it, finds these tags, and converts them into live, interactive fields for the signer. For the contract, the template includes tags like: {{Customer_Sign_es_:signer1:signature}} {{Date_Of_Signature_es_:signer1:date}} {{Financial_Institution_es_:signer1}} {{BSB_Number_es_:signer1}} {{Account_Name_es_:signer1}} {{Account_Number_es_:signer1}} Each tag follows Adobe's syntax: a field name, the _es_ identifier, the signer role (signer1), and an optional field type (signature, date, or left blank for a plain fillable text box). Because these tags are just text, they can sit anywhere in the Word template exactly where the business wants the field to appear — no separate field-placement tool required. Getting this right matters more than it looks. A few lessons learned building this out: The entire tag must stay on a single line and in a common font — if it wraps across a line break during merge or PDF conversion, Adobe won’t recognize it, and the raw tag text stays visible instead of becoming a field. Field type directives are limited to what Adobe actually supports (signature, date, initials, etc.) — leaving the type off entirely creates a plain fillable text field, which is what was used for the banking detail fields here. Converting the merged Word document to PDF before sending it to Adobe Sign tends to produce more consistent tag detection than sending the raw .docx. Because the tags are static text baked into the template, no extra configuration is needed in Power Automate to "activate" detection — it happens automatically the moment the document is sent to Adobe Sign for signature. Step 3: Sending the Contract for Signature Once the Word template is fully populated, the flow hands it off to Adobe Acrobat Sign using the Create an agreement from a file content and send for signature action — passing the merged file straight through, along with the signer's name, email, and role. At this point, two things happen simultaneously: a) The customer's Contact person receives … Continue reading From Quote to Signed Contract in Minutes: Automating Adobe Acrobat Sign Integration for an Australia based Linen and Garments company

Share Story :

How AI-Powered Meeting Briefings Are Transforming Client Preparation for a Boston based Private Equity Firm

Summary We built an AI-powered meeting briefing solution on top of Dynamics 365 CRM that assembles a complete, structured briefing – customer details, meeting history, email insights, professional profile, and open action items – with a single button click, delivered in under 30 seconds. Powered by Azure Functions and Azure OpenAI GPT-4.1, the solution sits inside the existing CRM workflow with zero change to the tools the team already uses. Built for private equity and asset management firms where missing context isn’t just inefficient – it’s a credibility cost. Table of Contents 01Summary 02Customer 03Challenge 04Solution 05Architecture 06Briefing 07Intelligence 08Enterprise 09Benefits 10Why PE About the Customer Customer Overview Our customer is a US based private equity investment firm focused on partnering with and growing businesses over the long term. With a portfolio of investments and a strong emphasis on operational excellence and value creation, the firm required an AI-powered solution to streamline client preparation, consolidate information from multiple sources, and enable investment professionals to make more informed decisions before meetings. The Challenge Data Exists. Context Doesn’t. Modern CRM platforms are excellent at storing information. On their own, they’re not built to assemble it into something a person can use in the next fifteen minutes. It’s 8:45 AM. Fifteen minutes before an important client call, a relationship manager has four tabs open – CRM, Outlook, LinkedIn, and a folder of old meeting notes – trying to reconstruct the relationship before the call starts. Nothing here is missing. It’s just scattered. And the fifteen minutes meant for preparing get spent finding what to prepare instead. As firms manage more relationships – more portfolio companies, more LPs, more prospects – this problem doesn’t stay the same size. It grows with every account added to the book. A typical prep routine still looks like this: 01Reviewing CRM records for account history 02Reading through recent email threads 03Searching old meeting notes for what was actually discussed 04Looking up a contact’s current role and background 05Trying to remember what was promised – and what’s still open Each source holds something useful on its own. None of them, alone, tells the whole story – and stitching them together by hand is what actually eats the morning. The result is inconsistent prep, lost productivity, and context that depends entirely on who happens to be covering the account that day. Today 01Manually researching each contact across CRM, LinkedIn, and email 02Meeting notes scattered across CRM records, shared drives, and inboxes 03Generic AI summaries that miss relationship context 04Key background often missed before the meeting even starts With AI-Powered Briefings 01A structured briefing generated in the team’s own template, on demand 02Contact details, professional background, and CRM data pulled automatically 03Past meetings and email threads summarized with real context 04The team arrives prepared in seconds, not hours Turning CRM Data Into Meeting Intelligence One Click. A Complete Briefing. We built an AI-powered meeting briefing solution that sits directly on top of Dynamics 365 CRM — adding a single button to the record teams already work from, with no change to the existing workflow underneath it. 01 Click The relationship manager clicks “AI Meeting Insights” on the contact or prospect record – the trigger for everything that follows. 02 Gather Azure Functions orchestrates the retrieval: CRM history, grouped email threads, past meeting notes, and the contact’s public professional profile. 03 Analyze Azure OpenAI GPT-4.1 reads everything chronologically, identifying what was discussed, what’s outstanding, and the tone of recent exchanges. 04 Deliver A formatted briefing, built in the team’s existing template, lands in minutes — a progress indicator keeps the user informed while it runs. In practice, the full sequence — from button click to finished document – runs in under 30 seconds. Solution Architecture How It Works — End to End From a single button click in Dynamics 365 to a formatted briefing delivered in under 30 seconds. Inside the Document What’s Actually in the Briefing Instead of a generic summary, the output is built around the fields teams actually need before walking into a conversation. 01 Customer & Contact Details Pulled directly from the CRM record — no re-typing, no re-checking. 02 Previous Meeting Summary Condensed from historical notes into a concise interactions record. 03 Recent Email Insights Key topics and sentiment from the latest correspondence. 04 Business Overview A short, current description of the company and its context. 05 Meeting Attendees Who’s expected in the room, drawn from calendar and CRM data. 06 Professional Profile Reference Publicly available background on the contact, added automatically. The Intelligence Behind the Briefing Structured, Not Just Summarized What makes this different isn’t simply the use of Generative AI — it’s the structure behind it. Rather than summarizing documents in isolation, the model reads a customer’s engagement history chronologically: completed and upcoming meetings, attendees, recent conversations, sentiment, and open action items, resolved into one coherent picture. Every section of the briefing is mapped back to a defined source. Customer details come from CRM. Meeting summaries come from meeting records. Communication insights come from email. Profile information is referenced separately and flagged as such. That traceability is what keeps the output contextual and consistent, rather than a plausible-sounding but generic AI summary. It’s also reviewed, not just trusted. Fields the model is less confident about are flagged for a human to check, and the team approves AI-generated sections before a briefing goes out. The goal isn’t to remove judgment from the process — it’s to remove the search that used to come before it. Built for the Enterprise Enterprise-Ready by Design This runs inside the systems and controls teams already trust — not alongside them. 01 Role-Based Access Visibility follows existing Dynamics 365 security roles — no new permission model to manage. 02 Data Protection Data is encrypted in transit, credentials sit in a secure Azure vault, and only the fields needed reach the model. 03 Graceful Failure Handling A failed run is flagged clearly, prior briefing data stays intact, and the user can … Continue reading How AI-Powered Meeting Briefings Are Transforming Client Preparation for a Boston based Private Equity Firm

Share Story :

How a Leading North American Commercial Vehicle Manufacturer Prevented Incorrect Purchase Prices on Purchase Orders Using Dynamics 365 Finance & Operations

Summary A leading North American commercial vehicle manufacturer was experiencing incorrect purchase prices on Purchase Orders in Dynamics 365 Finance & Operations. The root cause: overlapping trade agreement records in the PriceDiscTable that were never closed when new prices were introduced. CloudFronts diagnosed the issue and implemented a single rule – close the active trade agreement record before creating a new one – enforced through automation on both inbound integrations and manual entry workflows. The result: deterministic price resolution, clean audit trails, and procurement teams that trust the system again. Table of Contents 01Summary 02Customer 03Why it matters 04Our perspective 05Price logic 06Problem 07Fix 08Example 09Automation 10Edge cases 11Conclusion About the Customer Customer Overview Our customer is one of North America’s leading manufacturers of heavy-duty commercial vehicles, operating an extensive network of manufacturing and logistics facilities. As part of its supply chain operations, the organization manages high-volume production, component manufacturing, and distribution processes that require seamless integration across enterprise systems. For growing businesses running Dynamics 365 Finance & Operations, procurement accuracy is non-negotiable. As order volumes climb and vendor pricing evolves, even a small gap in how purchase prices are managed can quietly erode margins, trigger invoice disputes, and undermine trust in the system. One of the most common and most overlooked causes of pricing errors on Purchase Orders is something surprisingly simple: outdated trade agreement records that were never closed. Have you ever updated a vendor’s price in D365 FO, only to find that Purchase Orders raised the next week still show the old price? If you’re nodding, this article is for you. Consider this: organisations that leave overlapping trade agreement records unmanaged often find hundreds, sometimes thousands, of duplicate active price records for the same Item x Vendor combination in their PriceDiscTable. Each one is a potential pricing conflict waiting to surface on a Purchase Order. The cumulative effect on procurement accuracy, AP reconciliation time, and vendor relationships is significant. By the end of this article, you will understand exactly why this happens, how D365 FO’s price engine actually resolves trade agreements, and the single rule that eliminates the problem entirely. Why This Matters Incorrect Purchase Prices Create Real Business Risk Incorrect purchase prices on POs are not just a data nuisance. They lead to overpayments that chip away at margins, invoice mismatches that clog up Accounts Payable, and worst of all, procurement teams who stop trusting the system and start overriding prices manually on every order. Once that happens, the entire value of centralized pricing governance is gone. Why We’re Writing This A Pattern We See Across D365 F&O Implementations At CloudFronts, we’ve implemented and supported Dynamics 365 F&O procurement modules across manufacturing, distribution, and services organisations. This specific issue, stale trade agreements causing wrong PO prices, has come up in nearly every engagement where vendor prices are managed through the Trade Agreement Journal. We’ve seen the pattern, diagnosed the root cause repeatedly, and built the automation to prevent it. This article distils that experience into something actionable. How D365 F&O Resolves Purchase Prices The Price Comes From Trade Agreements, Not the Item Master The price on a Purchase Order line does not come from the item master. It is resolved from a Trade Agreement, a dated record that says: “For this item, from this vendor, in this currency, starting from this date, the unit price is X.” These records are created through the Trade Agreement Journal, posted, and stored in the PriceDiscTable. When a PO line is created, the price search engine finds every posted record whose date window, from From Date to To Date, covers the PO date. It then filters by matching keys such as item, vendor, currency, site, warehouse, and quantity break, and selects the price. Critically, the system does not prefer the most recently posted record. It looks at date windows. If two records both cover today, the engine has two valid candidates. Its tie-breaking behaviour is not something you should rely on for pricing accuracy. The Problem Overlapping Records Create Pricing Conflicts Here’s how the issue plays out. A vendor price is loaded into D365 FO, either from a legacy system integration or manually by a buyer. The record is created with an open-ended To Date, the sentinel 1900-01-01 or a far-future date, meaning it never expires. Months later, a new negotiated price arrives. A fresh trade agreement line is added for the same Item x Vendor. But nobody closes the original record. Both records now have date windows that include today. The price engine finds two matches, and sometimes the older, stale price wins. Root Cause There is no closure step. Every new price is layered on top of the old one instead of replacing it in time. The Fix Close Before You Create The rule is simple: whenever a new price record is created for an Item x Vendor combination, the currently active record must have its To Date set to Today – 1. The new record’s From Date is set to Today. This produces two non-overlapping windows: old price valid up to yesterday, new price effective from today. Why Today – 1? If both dates include the same day, the engine still finds two candidates. One day’s difference makes the price resolution deterministic. Worked Example One Item, One Vendor, One Clean Price Timeline Item purchased from Vendor A, USD, quantity break of 1: Event Action From Date To Date Price 22 June – Initial load Create Record A 22 June 2026 Open-ended $7.00 24 June – New price Close Record A 22 June 2026 23 June 2026 $7.00 24 June – New price Create Record B 24 June 2026 Open-ended $6.50 After posting, any PO dated 24 June or later picks $6.50. Historical POs on or before 22 June still resolve to $7.00. Clean, unambiguous, audit safe. Where to Enforce This Rule Automation Should Handle the Closure Inbound Integration If prices flow from a legacy system via OData, build a custom API endpoint in D365 FO that … Continue reading How a Leading North American Commercial Vehicle Manufacturer Prevented Incorrect Purchase Prices on Purchase Orders Using Dynamics 365 Finance & Operations

Share Story :

No Plugin, No Flow: Auto-Propagating Legal Entity Across 18 D365 Tables Using Formula Fields

No Plugin, No Flow: Auto-Propagating Legal Entity Across 18 D365 Tables Using Formula Fields Summary As part of our internal PO (Project Operations) to F&O integration product, every transaction needs to know which legal entity it belongs to — yet no out-of-box mechanism exists to propagate this across the 18+ connected tables involved. We built a zero-code, zero-maintenance solution using Dataverse formula fields: set Legal Entity once on Account, and every related record inherits it automatically. A custom Legal Entity table maps company master records to FO DataAreaId codes, and formula fields chain the value down through the entire relationship hierarchy. Three entities with polymorphic lookups blocked formula traversal — solved with a direct lookup field auto-populated via a Business Rule, requiring no user action. Business impact: eliminated manual per-record entry, removed CRM–FO mismatch risk, and replaced plugin/flow maintenance overhead with pure declarative formula fields. Table of Contents 01 Summary 02 The Challenge 03 What We Built 04 How It Works 05 The One Technical Wall 06 The Outcome 07 The Bigger Point 08 FAQs 09 Conclusion 10 About Me The Challenge In our internal PO (Project Operations) to F&O integration product, every transaction needs to know which legal entity it belongs to — yet no out-of-box mechanism exists to auto-propagate this across the 18+ connected tables involved. The traditional approach? Manual entry, plugins, or complex flows — all high maintenance, all error-prone. What We Built A zero-code, zero-maintenance auto-propagation solution using Dataverse formula fields — no plugin, no Power Automate flow for downstream entities. The core idea: set Legal Entity once on Account. Every related record inherits it automatically. How It Works One custom table — Legal Entity — stores company master records mapped to FO DataAreaId codes (e.g. ac, USMF). One manual input — user sets Legal Entity on Account. That’s it. Everything else is automatic — formula fields chain through the relationship hierarchy. Account (set once) → Contact, Project Contract, Invoice → Contract Lines, Projects → Tasks, Time Entries, Expenses, Actuals, Team Members, Role Prices… The One Technical Wall Three entities — Contact, Salesorders, Invoices, Projects — use polymorphic lookup fields that block formula traversal. Solved by adding a clean direct lookup — cf_accountref — populated automatically via a Business Rule. No user action needed. The Outcome Before After Legal Entity entered manually per record Set once on Account — cascades to 18 tables Risk of mismatch between CRM and FO Single source of truth — always in sync Plugin or flow required for automation Pure formula fields — zero maintenance Existing records needed manual update One-time bulk flow backfilled all records The Bigger Point Data Governance Principle This isn’t just a technical pattern — it’s a data governance principle: in multi-entity implementations, master attributes should live at the top of the hierarchy and flow down automatically, not be re-entered at every level. Formula fields make this possible in Dataverse without a single line of code. Frequently Asked Questions Why not just use a plugin or Power Automate flow instead? Plugins and flows both introduce ongoing maintenance overhead — deployment, error handling, throttling limits, and monitoring. Formula fields are declarative, run natively inside Dataverse, and require no execution infrastructure or upkeep. What happens when a polymorphic lookup blocks the formula chain? Dataverse formula fields can’t traverse polymorphic (multi-target) lookups directly. The fix is a dedicated single-target lookup field, populated automatically by a Business Rule, that formula fields can then reference downstream. Does this approach scale beyond 18 tables? Yes. As long as each new table has a traceable relationship path back to Account (directly or through an intermediate entity), a formula field can be added to inherit Legal Entity without any additional plugin or flow logic. What about records that already existed before this was implemented? A one-time bulk update was run to backfill Legal Entity on existing records. Going forward, all new and related records inherit the value automatically through the formula field chain. Conclusion Legal Entity tracking is a small field with outsized consequences — get it wrong, and financial reporting, cross-entity reconciliation, and downstream automation all inherit the error. The instinct in most implementations is to reach for a plugin or a flow to keep it in sync. This solution proves that’s not always necessary. By anchoring Legal Entity at the top of the hierarchy on Account and letting Dataverse formula fields carry it down through 18 connected tables, we removed an entire category of maintenance — no custom code to patch, no flow runs to monitor, no throttling limits to worry about. The system simply stays correct by design. It’s a reminder that the most resilient integrations are often the ones that need the least ongoing attention. When a platform-native feature can solve a problem cleanly, it usually outlasts a custom-built one. About Me DC Author Deepak Chauhan Consultant and Databricks Certified Data Engineer with 4 years of experience across Dynamics 365, Data & AI, and BI. Building Something Similar? If you’re wrestling with multi-entity data consistency in Dataverse or D365, formula fields might solve more than you expect — before you reach for a plugin or a flow. Get in Touch

Share Story :

Transforming Accounts Payable with AI: Configuring the Payables Agent in Microsoft Dynamics 365 Business Central for the Cradle to Cradle Products Innovation Institute (C2CPII)

Summary This blog explores how the Payables Agent in Microsoft Dynamics 365 Business Central (2025 Release Wave 1) transforms traditional Accounts Payable (AP) processes by leveraging AI to automate invoice processing for a Netherlands-based non-profit organization. Traditionally, finance teams spend considerable time manually entering invoice information, validating vendors, creating purchase invoices, and ensuring document accuracy. As invoice volumes grow, these repetitive tasks become increasingly time-consuming and susceptible to human error. The Payables Agent introduces an AI-assisted approach that automatically monitors a designated mailbox, extracts invoice information from PDF documents, identifies vendors, creates draft purchase invoices, and routes them for supervisor review before posting. This blog explains: The challenges associated with traditional Accounts Payable processing. How the Payables Agent works in Business Central. The configuration steps required to activate the agent. The end-to-end AI-powered invoice processing workflow. The business impact of automating Accounts Payable. Table of Contents Customer Scenario Business Challenges Solution Overview Solution Architecture Configuring the Payables Agent AI-Powered Invoice Processing Workflow Supervisor Review Process Business Impact Disclaimer FAQs Conclusion 1. Customer Scenario A finance department within a Netherlands-based non-profit organization processing hundreds of vendor invoices each month was experiencing increasing pressure to improve efficiency while maintaining financial accuracy and compliance. Invoice processing relied heavily on manual data entry. Finance users were responsible for opening incoming emails, downloading invoice PDFs, entering purchase invoice information into Business Central, validating vendors, and ensuring data accuracy before posting transactions. As invoice volumes continued to increase, the organization needed a smarter and more scalable solution capable of reducing repetitive work without compromising financial controls. The organization decided to leverage the new AI-powered Payables Agent introduced in Microsoft Dynamics 365 Business Central 2025 Release Wave 1. 2. Business Challenges The existing Accounts Payable process presented several operational challenges. 1. Manual Invoice Entry Finance users manually entered invoice information into Business Central, increasing processing time and effort. 2. Vendor Validation Each invoice required verification against existing vendor records before processing could continue. 3. Repetitive Administrative Work Processing hundreds of invoices each month resulted in significant administrative overhead and reduced productivity. 4. Human Errors Manual entry increased the likelihood of incorrect invoice values, vendor selection mistakes, and duplicate invoice processing. 5. Delayed Invoice Processing Large invoice volumes often delayed purchase invoice creation and subsequent payment processing. Business Need The organization required an intelligent solution capable of automating repetitive Accounts Payable activities while allowing finance teams to retain complete control over invoice validation and final approvals. 3. Solution Overview Microsoft introduced the Payables Agent as part of the AI capabilities available in Microsoft Dynamics 365 Business Central 2025 Release Wave 1. The agent is designed to streamline Accounts Payable operations by automating repetitive invoice processing tasks while maintaining financial controls. The Payables Agent continuously monitors a configured mailbox for incoming vendor invoice PDFs. Once a new invoice is detected, it automatically analyzes the document, extracts key information using AI, identifies the appropriate vendor, and prepares a draft purchase invoice for review. Once an invoice is received, the Payables Agent automatically performs the following tasks: Reads invoice information from the PDF document. Identifies the corresponding vendor. Extracts invoice header and line details. Creates a draft Purchase Invoice in Business Central. Notifies supervisors that a draft invoice is ready for review. Allows users to validate, finalize, and post the purchase invoice. Key Benefit: Rather than replacing finance professionals, the Payables Agent acts as an intelligent assistant that automates repetitive Accounts Payable activities while preserving financial governance, approval controls, and auditability. 4. Solution Architecture The Payables Agent follows a streamlined AI-assisted workflow that automates the processing of vendor invoices while ensuring finance teams retain full control over validation and posting. From receiving an invoice to creating a draft purchase invoice, each stage is designed to reduce manual effort and improve processing efficiency. Process Flow Vendor emails the invoice PDF to the designated mailbox. The invoice is received in the configured mailbox. The Payables Agent continuously monitors the mailbox for new invoices. AI Document Intelligence extracts the invoice information. The system matches the invoice with an existing vendor. A draft Purchase Invoice is automatically created. A supervisor reviews and validates the extracted information. The Purchase Invoice is finalized and posted into Business Central. Architecture Overview: The Payables Agent combines AI-powered document processing, automated vendor matching, and draft purchase invoice creation with human review to deliver a faster, more accurate, and well-governed Accounts Payable process. Core Components The following components work together to automate the invoice processing lifecycle while ensuring appropriate financial controls and governance. Component Purpose Vendor Email Sends vendor invoice PDFs to the designated mailbox. Configured Mailbox Receives incoming vendor invoices for processing. Payables Agent Monitors the mailbox and orchestrates the AI-driven invoice processing workflow. AI Document Intelligence Extracts invoice details such as vendor information, invoice number, dates, amounts, and line items. Vendor Matching Engine Matches extracted invoice data with existing vendor records in Business Central. Draft Purchase Invoice Automatically creates a draft purchase invoice using the extracted invoice information. Supervisor Review Allows finance users to validate the extracted information before posting. Purchase Posting Finalizes and posts the approved purchase invoice into Business Central. Key Takeaway: By combining AI-powered document intelligence with Business Central’s standard purchasing process, the Payables Agent minimizes manual data entry while ensuring every invoice is reviewed and validated before posting. 5. Configuring the Payables Agent Step 1 – Open the Payables Agent From the top-right corner of Microsoft Dynamics 365 Business Central, select the AP (Accounts Payable) icon to access the Payables Agent. Step 2 – Activate the Agent Enable the Payables Agent to begin AI-assisted invoice processing. Once activated, the agent becomes available to monitor incoming invoices and assist with the automatic creation of purchase invoices. Step 3 – Connect the Mailbox Configure the mailbox that will receive vendor invoice PDFs. The Payables Agent continuously monitors this mailbox and automatically imports incoming invoice documents as they arrive. After successful processing, the invoices are archived for future reference within Business Central. Step 4 – Vendor Matching … Continue reading Transforming Accounts Payable with AI: Configuring the Payables Agent in Microsoft Dynamics 365 Business Central for the Cradle to Cradle Products Innovation Institute (C2CPII)

Share Story :

How Project-Based Profitability Reporting Turns Dynamics 365 PSA Data into Better Business Decisions

How Project-Based Profitability Reporting Turns Dynamics 365 PSA Data into Business Decisions Summary Managing multiple customer engagements means thousands of monthly records — time entries, resource allocations, invoices, and project costs — yet this data often remains fragmented across systems, making it difficult to answer one critical question: “Is this project actually profitable?” We built a comprehensive profitability reporting solution using Dynamics 365 PSA and Power BI for a Microsoft Solutions Partner headquartered in Texas, USA, delivering enterprise technology services across multiple practice areas. The solution unifies financial and operational data into two complementary dashboards: an Executive Profitability Overview for leadership and a Detailed Hours & Financial Analysis page for project managers. Key capabilities include continuous gross margin monitoring, resource utilization tracking linked directly to profitability, solution-area performance analysis, and dynamic filtering by project, manager, status, and date. Business impact: manual financial reconciliation was replaced with automated real-time dashboards — enabling earlier margin interventions, reduced revenue leakage, and faster executive decision-making. Table of Contents 01 Summary 02 About the Customer 03 The Challenge 04 The Solution 05 Executive Dashboard 06 Profitability Trends 07 Resource Utilization 08 Business Impact 09 FAQs 10 Conclusion About the Customer Customer Spotlight A Microsoft Solutions Partner — Texas, USA Our customer is a leading Microsoft solutions provider headquartered in Texas, USA, delivering enterprise solutions across cybersecurity, cloud infrastructure, systems management, mobility, and business intelligence. With numerous customer projects running simultaneously, leadership required a centralized reporting solution to monitor project financial health across the organization. The Challenge Most organizations using Dynamics 365 PSA successfully capture operational data. The problem isn’t collecting it — the problem is connecting it into meaningful business insights. Project managers frequently found themselves asking: 1Which engagements are generating healthy margins? 2Which projects are consuming more cost than expected? 3How much revenue has actually been billed? 4Are allocated resources being utilized efficiently? 5Which solution areas contribute the highest profitability? Answering these questions required manually comparing multiple reports across finance, operations, and project management. By the time profitability issues were discovered, corrective action was often too late. The Solution To eliminate fragmented reporting, we designed a centralized Engagement Profitability Report in Power BI using Dynamics 365 PSA as the primary data source. The report is divided into two complementary dashboards: Executive Profitability Overview Strategic visibility with consolidated KPIs, margin trends, and interactive portfolio filters for leadership teams. Detailed Hours & Financial Analysis Operational drill-down to engagement and resource level, enabling project managers to trace profitability directly. Dynamics 365 PSA Integration Primary data source connecting contracts, actuals, time entries, invoices, and resource allocations in one model. Power BI Analytics Layer Dynamic filtering, trend analysis, treemap solution-area breakdowns, and real-time gross margin monitoring. Executive Profitability Dashboard The executive dashboard provides leadership with an instant view of project performance. It consolidates key KPIs into one interactive page: Total Contract Value Original Contract Amount Change Orders & Value Total Cost Incurred Gross Margin Amount Gross Margin % Billable Hours Non-Billable Hours Invoice Amount The dashboard also includes interactive filters for Project Status, Project, Project Manager, and Date Range — enabling instant analysis across any project portfolio without rebuilding reports. Profitability Trends Over Time One of the most valuable capabilities is tracking profitability throughout the project lifecycle rather than waiting until project closure. Management can continuously monitor: Monthly cost incurred vs. monthly billable revenue Invoice trends and billing progress Gross margin performance over time These trend analyses quickly surface rising project costs, revenue slowdowns, billing delays, and margin deterioration — transforming profitability reporting from a historical exercise into an operational management tool. “A project may have a high contract value but low billable utilization, delayed invoicing, and increasing delivery costs — the report surfaces this gap immediately.” Resource Utilization Insights People are the largest investment in professional services organizations. The report compares Allocated Hours, Billable Hours, and Non-Billable Hours at both project and individual resource levels, helping managers identify: Under-utilized consultants Excessive non-billable work patterns Resource allocation imbalances across engagements Delivery efficiency trends by team member Instead of tracking utilization in isolation, the report links it directly to project profitability through resource-level cost breakdowns showing Role, Allocated Hours, Billable Revenue, and Delivery Cost per person. Solution Area Performance Using Power BI treemap visualizations, the report analyzes profitability across Solution Areas, Solution Plays, and Business Units — enabling strategic questions such as: Which service offerings generate the highest margins? Which solution areas consume the highest delivery cost? Where should future investment be focused? Business Impact Before After Multiple disconnected operational reports Unified profitability dashboard Manual financial reconciliation Automated real-time reporting Limited visibility into project margins Continuous gross margin monitoring Separate operational and financial analysis Single integrated business view Difficult executive reporting Interactive executive dashboards Resource utilization tracked independently Utilization linked directly to profitability Frequently Asked Questions Does Dynamics 365 PSA provide profitability reporting out of the box? Dynamics 365 PSA captures the underlying operational data, but organizations typically require customized Power BI reports to combine contracts, costs, invoices, resources, and profitability metrics into meaningful business insights. Why combine operational and financial data in one report? Project profitability depends on multiple factors including hours worked, delivery cost, billing progress, and contract value. Bringing these together provides a complete view of project health and supports faster, more informed decisions. Who benefits most from this type of report? Executive leadership, project managers, finance teams, PMOs, and delivery managers all benefit. Executives gain portfolio-level visibility, while project managers can investigate profitability at the engagement and resource levels. Can this be extended to other Dynamics 365 modules? Yes. The same Power BI model can be extended to incorporate data from Dynamics 365 Finance & Operations, including actuals from Project Accounting, enabling even deeper financial reconciliation across modules. Conclusion Project success is measured by more than completed tasks or delivered hours — it is ultimately defined by profitability. By bringing together Dynamics 365 PSA operational data and Power BI analytics, organizations gain a real-time view of project financial performance. Instead of asking “Was the project … Continue reading How Project-Based Profitability Reporting Turns Dynamics 365 PSA Data into Better Business Decisions

Share Story :

Modernizing Payment Approval Email Notifications in Microsoft Dynamics 365 Business Central Without Changing Standard Workflow Logic for a Maldives-Based Loan and Financial Services Organization

Summary Approval workflows in Microsoft Dynamics 365 Business Central provide a structured mechanism for multi-level document approvals. However, the standard approval email often lacks sufficient business context, making it difficult for approvers to take quick and informed decisions. In this implementation, for a Maldives-based loan and financial services organization, instead of modifying the core approval engine, we enhanced only the notification layer using Business Central’s event-driven architecture. The solution intercepts standard approval notifications and replaces them with a custom HTML email containing payment details and direct navigation links to the Payment Journal. This approach ensures the standard workflow remains fully intact while significantly improving the approval experience through richer and more actionable communication. Standard Business Central approval workflow remains unchanged. Custom HTML email notification introduced via an event-driven extension. Direct navigation to the Payment Journal enabled from the email. Faster and more informed approval decisions. Table of Contents Introduction Business Requirement Solution Overview Implementation Preview Video Business Impact Conclusion 1. Introduction Microsoft Dynamics 365 Business Central includes a powerful approval workflow engine that automates document approvals, supports multi-level approval chains, and automatically notifies approvers through email. Although the standard approval process works exceptionally well, the default email notification is intentionally simple. Approvers typically receive limited information and often need to open Business Central to locate the payment journal before they can review or approve the request. For organizations processing large volumes of financial transactions in a Maldives-based loan and financial services environment, this additional navigation slows down approvals and creates unnecessary effort. During one of our recent implementations in a Maldives-based lending and financial operations setup, the client wanted to improve the approval experience without changing Microsoft’s standard approval workflow. The objective was to retain every aspect of the existing workflow while enhancing only the email notification layer by introducing a modern, information-rich HTML email format. 2. Business Requirement The client wanted to achieve the following objectives: Preserve the standard Microsoft Dynamics 365 Business Central approval workflow. Keep all approval entries and workflow responses unchanged. Replace the standard approval email with a professional HTML email. Display important payment information directly inside the email body. Allow approvers to open the Payment Journal with a single click. Improve the overall approval experience without modifying Microsoft’s workflow engine. The primary goal was to enhance usability while maintaining full compatibility with the standard Business Central approval framework. 5. Preview Video The preview video section has been removed as per updated requirement. 6. Business Impact Implementing customized approval email notifications delivered several operational benefits while keeping Microsoft’s standard workflow engine fully intact. Improved User Experience Approvers receive all important payment information directly within the email, reducing the need to navigate through Business Central before reviewing requests. Faster Approval Decisions Direct navigation to the Payment Journal enables approvers to review and process approvals much more quickly. Better Visibility Payment amount, vendor information, posting date, and approval sequence are immediately visible, making approvals easier and reducing the chance of overlooking important details. Easier Document Verification Supporting invoice attachments can be reviewed directly from the Payment Journal before approving payments. Upgrade-Friendly Solution Because the implementation relies entirely on standard Microsoft Dynamics 365 Business Central events, no modifications are made to the core approval engine, ensuring future upgrades remain smooth and low-risk. 7. Conclusion Microsoft Dynamics 365 Business Central’s event-driven extensibility model allows developers to significantly enhance the user experience without modifying standard application logic. By leveraging the OnBeforeCreateApprovalEntryNotification event, we replaced the default approval email with a professional HTML notification while preserving the complete standard approval workflow. Approvers now receive richer payment information, can navigate directly to the Payment Journal, and have quick access to supporting documents—all without altering Microsoft’s workflow engine. This implementation demonstrates how targeted customizations can greatly improve productivity and usability while remaining fully aligned with Microsoft’s recommended extension development practices. Ready to modernize your Business Central approval experience? Standard approval emails often lack context, forcing approvers to open Business Central repeatedly just to review basic payment details. With event-driven customization, you can transform these notifications into rich, structured HTML emails that improve decision-making speed and user experience. CloudFronts helps organizations extend Microsoft Dynamics 365 Business Central with smart, upgrade-safe customizations, workflow enhancements, and finance automation solutions. For more information, reach out at transform@cloudfronts.com.

Share Story :

SEARCH BLOGS:

FOLLOW CLOUDFRONTS BLOG :


Categories

Secured By miniOrange